export const ResearchGroupQueries = {
    GetResearchGroups: `
    SELECT
      id,
      researchGroupName,
      researchGroupOwnerId,
      researchGroupOwnerName,
      researchGroupOwnerEmployeeId,
      researchGroupOwnerPhone,
      researchGroupOwnerEmail,
      researchGroupDepartment,
      researchGroupDirection,
      researchGroupCreatedDate,
      researchGroupSubject,
      researchGroupMembers,
      project_id
    FROM my_schema.research_group
    `,
  
    GetResearchGroupById: `
    SELECT
      id,
      researchGroupName,
      researchGroupOwnerId,
      researchGroupOwnerName,
      researchGroupOwnerEmployeeId,
      researchGroupOwnerPhone,
      researchGroupOwnerEmail,
      researchGroupDepartment,
      researchGroupDirection,
      researchGroupCreatedDate,
      researchGroupSubject,
      researchGroupMembers,
      project_id
    FROM my_schema.research_group
    WHERE
      id = ?
    `,

    GetResearchGroupByOwnerId: `
    SELECT
      id,
      researchGroupName,
      researchGroupOwnerId,
      researchGroupOwnerName,
      researchGroupOwnerEmployeeId,
      researchGroupOwnerPhone,
      researchGroupOwnerEmail,
      researchGroupDepartment,
      researchGroupDirection,
      researchGroupCreatedDate,
      researchGroupSubject,
      researchGroupMembers,
      project_id
    FROM my_schema.research_group
    WHERE
      researchGroupOwnerId = ?
    `,

    GetResearchGroupByName: `
    SELECT
      id,
      researchGroupName,
      researchGroupOwnerId,
      researchGroupOwnerName,
      researchGroupOwnerEmployeeId,
      researchGroupOwnerPhone,
      researchGroupOwnerEmail,
      researchGroupDepartment,
      researchGroupDirection,
      researchGroupCreatedDate,
      researchGroupSubject,
      researchGroupMembers,
      project_id
    FROM my_schema.research_group
    WHERE
      researchGroupName = ?
    `,
  
    AddResearchGroup: `
    INSERT INTO my_schema.research_group (researchGr/projectidoupName, researchGroupOwnerId, researchGroupOwnerName, researchGroupOwnerEmployeeId, researchGroupOwnerPhone, researchGroupOwnerEmail, researchGroupDepartment, researchGroupDirection, researchGroupCreatedDate, researchGroupSubject, researchGroupMembers, createdTime, updatedTime, project_id)
      VALUES ?
    `,

    UpdateResearchGroupById: `
    UPDATE my_schema.research_group
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteResearchGroupById: `
    DELETE FROM my_schema.research_group
    WHERE
      id = ?
    `
  };